/*
 * Filename : SOCQueryConstants.java 
 * Package :  com.spi.soconversion
 * Created by: Software Paradigms International Group, LLC. (SPI) 
 * Copyright (c) 2010 HBC
 */
package com.spi.soconversion.util;

/**
 * This class contains Constants look up for queries  
 * <p>
 * Issues:
 * <p>
 * NONE
 * <p>
 * History:
 * <p>
 * <ul>
 * <li>2010.04.29 pk: created
 * </ul>
 *
 * @author Priya Khanna, SPI (pk)
 */

public class QueryConstants
{
	
	/**
	 * Contains Look up for INSERT query for populating flat table for closed sales order.
	 */	
	public static final int INSERT_FLAT_TABLE_CLOSED_ORDERS_QUERY=2;
	
	
	/**
	 * Contains Look up SELECT query for looking up active install base.
	 */
	public static final int GET_ACTIVE_INSTALL_BASE_QUERY = 11;
	
	/**
	 * Contains Look up SELECT query for looking up ADDRESS for install base.
	 */
	public static final int GET_ADDRESS_INSTALL_BASE_QUERY = 12;
	
	/**
	 * Contains Look up SELECT query for looking up CONTACTS for install base.
	 */
	public static final int GET_CONTACTS_INSTALL_BASE_QUERY = 13;
	
	/**
	 * Contains Look up SELECT query for looking up NOTES for install base.
	 */
	public static final int GET_NOTES_INSTALL_BASE_QUERY = 14;
	
	/**
	 * Contains Look up SELECT query for looking up WARRANTY for install base.
	 */
	public static final int GET_WARRANTY_INSTALL_BASE_QUERY = 15;
	
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_INSTALL_BASE_INFO
	 */
	public static final int ANALYZE_ACTIVE_INSTALL_BASE_QUERY = 16;
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_INSTALL_BASE_ADDR
	 */
	public static final int ANALYZE_ADDRESS_INSTALL_BASE_QUERY = 17;
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_INSTALL_BASE_CONT
	 */
	public static final int ANALYZE_CONTACTS_INSTALL_BASE_QUERY = 18;
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_INSTALL_BASE_NOTES
	 */
	public static final int ANALYZE_NOTES_INSTALL_BASE_QUERY = 19;
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_INSTALL_BASE_WTY
	 */
	public static final int ANALYZE_WARRANTY_INSTALL_BASE_QUERY = 20;
	
	/**
	 * Contains Look up for SELECT query for batch number from CONVERSION_BATCH_RECORDS
	 */	
	public static final int SELECT_BATCH_NUMBER_QUERY=21;
	
	/**
	 * Contains Look up for SELECT query for total records processed from CONVERSION_BATCH_RECORDS
	 */	
	public static final int SELECT_TOTAL_RECORDS_PROCESSED_QUERY=22;
	
	/**
	 * Contains Look up SELECT query for looking up active install base.
	 */
	public static final int SELECT_FLAT_TABLE_INSTALLBASE_QUERY = 23;
	
	/**
	 * Contains Look up SELECT query for looking up all remaining active install base.
	 */
	public static final int SELECT_ALL_FLAT_TABLE_INSTALLBASE_QUERY = 24;	
	
	/**
	 * Contains Look up for SELECT query for notes from TBL_STAGING_INSTALL_BASE_NOTES
	 */	
	public static final int SELECT_FLAT_TABLE_INSTALLBASE_NOTES_QUERY=25;
	
	/**
	 * Contains Look up for SELECT query for notes from TBL_STAGING_INSTALL_BASE_WTY
	 */	
	public static final int SELECT_FLAT_TABLE_INSTALLBASE_WTY_QUERY=26;
	
	/**
	 * Contains Look up for INSERT query for CONVERSION_BATCH_RECORDS
	 */	
	public static final int INSERT_CONVERSION_BATCH_RECORDS_QUERY=27;	
	
	/**
	 * Contains Look up for SELECT query for total records to be processed from TBL_STAGING_INSTALL_BASE_INFO
	 */	
	public static final int SELECT_TOTAL_RECORDS_TO_BE_PROCESSED_QUERY=28;
	
	/**
	 * Contains Look up for INSERT query for updating errors to TBL_INSTALLBASE_CONVERSION_ERRORS
	 */	
	public static final int INSERT_INSTALLBASE_CONVERSION_ERRORS=29;
	
	
	/**
	 * Contains Look up SELECT query for looking up 13 month old closed sales order.
	 */
	public static final int GET_CLOSED_ORDERS_13_MONTH_OLD_QUERY = 31;
	
	/**
	 * Contains Look up SELECT query for looking up before 13 month old closed sales order with valid warranty.
	 */
	public static final int GET_CLOSED_ORDERS_BFR_13_MONTH_OLD_QUERY = 32;
	
	/**
	 * Contains Look up ANALYZE query for TBL_CLOSED_ORDERS_IN_13MONTHS
	 */
	public static final int ANALYZE_CLOSED_ORDERS_13_MONTH_OLD_QUERY = 33;
	
	/**
	 * Contains Look up ANALYZE query for TBL_CLOSED_ORDERS_BFR_13MONTHS
	 */
	public static final int ANALYZE_CLOSED_ORDERS_BFR_13_MONTH_OLD_QUERY = 34;
	
	/**
	 * Contains Look up SELECT query for looking up 13 month old closed order lines.
	 */
	public static final int GET_CLOSED_ORDERS_LINES_13_MONTHS_QUERY = 35;
	
	/**
	 * Contains Look up SELECT query for looking up prior to 13 month old closed order lines.
	 */
	public static final int GET_CLOSED_ORDERS_LINES_BFR_13_MONTHS_QUERY = 36;
	
	/**
	 * Contains Look up ANALYZE query for TBL_STAGING_CLOSED_ORDER_LINES
	 */
	public static final int ANALYZE_CLOSED_ORDERS_LINES_QUERY = 37;
	
	/**
	 * Contains Look up for SELECT query for total closed orders to be processed from CLOSED_SALES_SEQ
	 */	
	public static final int SELECT_TOTAL_CLOSED_ORDERS_TO_BE_PROCESSED_QUERY=38;
	
	/**
	 * Contains Look up SELECT query for looking up closed orders
	 */
	public static final int SELECT_CLOSED_ORDERS_QUERY = 39;
	
	/**
	 * Contains Look up SELECT query for looking up all remaining closed orders
	 */
	public static final int SELECT_ALL_CLOSED_ORDERS_QUERY = 40;
	
	/**
	 * Contains Look up SELECT query for looking up charge names
	 */
	public static final int GET_CHARGE_NAMES_QUERY = 41;
	
	/**
	 * Contains Look up SELECT query for looking up distinct pos store numbers for closed sales lines
	 */
	public static final int SELECT_DISTINCT_POS_STORE_QUERY = 42;
	
	/**
	 * Contains Look up INSERT query for inserting distinct pos store numbers for closed sales lines to table TBL_CLOSED_LINES_POS_PROVINCE
	 */
	public static final int INSERT_DISTINCT_POS_STORE_QUERY = 43;
	
	/**
	 * Contains Look up INSERT query for inserting pos PROVINCE for closed sales lines to table TBL_CLOSED_LINES_POS_PROVINCE
	 */
	public static final int INSERT_POS_PROVINCE_QUERY = 44;
	
	/**
	 * Contains Look up SELECT query for looking up pos store numbers and province
	 */
	public static final int GET_POS_STORE_PROVINCE_QUERY = 45;
	
	/**
	 * Contains Look up for INSERT query for updating messages to TBL_CLOSED_ORDER_STATISTICS
	 */	
	public static final int INSERT_CLOSED_ORDER_CONVERSION_STATISTICS=46;
	
	
	/**
	 * Contains Look up for INSERT query for updating orders to TBL_CONVERTED_CLOSED_ORDERS
	 */	
	public static final int INSERT_CONVERTED_CLOSED_ORDERS=47;
	
	/**
	 * Contains Look up for Order header for the line id in installbase
	 */	
	public static final int INSTALL_BASE_FIND_ORDER=49;
	/**
	 * Contains Look up for lines details of the order found using above query
	 */	
	public static final int INSTALL_BASE_FIND_ORDER_LINES=50;
	
	
	//----------------------------------------------------------------------------------------------
	// Query constants for Open Sales Order Module
	//----------------------------------------------------------------------------------------------
	
	//**********************************************************************************************
	// APPLICATION - SQL
	//
	// 1. CONVERSION_BATCH_RECORDS - To maintain the converted records.
	// 2. TBL_OPEN_SALES_ORDER_ERRORS - To maintain the error information occurred during processing. 
	// 3. TBL_OPEN_SALES_ORDER_CONVERSION_ERRORS - To maintain the error information occurred during conversion.
	//**********************************************************************************************

	/**
	 * SELECT query for total records to be processed from TBL_STG_OPEN_ORDER_LINES
	 */	
	public static final int OSO_GET_TOTAL_RECORDS_TO_BE_PROCESSED_QUERY=411;

	/**
	 * SELECT query for getting a batch number from TBL_STG_OPEN_ORDER_LINES
	 */		
	public static final int OSO_GET_BATCH_NUMBER_QUERY=412;
	
	/**
	 * SELECT query for total records processed from CONVERSION_BATCH_RECORDS
	 */	
	public static final int OSO_GET_TOTAL_RECORDS_PROCESSED=413;
	
	/**
	 * INSERT query for CONVERSION_BATCH_RECORDS
	 */
	public static final int OSO_INSERT_CONVERSION_BATCH_RECORDS_QUERY=414;
		
	/**
	 * INSERT query for updating errors to TBL_OPEN_SALES_ORDER_ERRORS
	 */	
	public static final int OSO_INSERT_OPEN_SALES_ORDER_CONVERSION_ERRORS=415;

	public static final int INSERT_OPEN_ORDER_CONVERSION_STATISTICS = 416;
	
	public static final int INSERT_CONVERTED_OPEN_ORDERS = 417;
	
	/**
	 * Contains Look up SELECT query for looking up closed orders
	 */
	public static final int SELECT_OPEN_ORDERS_QUERY = 421;
	
	/**
	 * Contains Look up SELECT query for looking up all remaining closed orders
	 */
	public static final int SELECT_ALL_OPEN_ORDERS_QUERY = 422;
	
	//**********************************************************************************************
	// FUNCTIONAL - SQL
	//**********************************************************************************************
	
	/**
	 * SELECT query for collected all the records from TBL_STG_OPEN_ORDER_LINES
	 */
	public static final int GET_ALL_OPEN_SALES_ORDERS = 401;
		
	/**
	 * SELECT query for a given order number from TBL_STG_OPEN_ORDER_LINES
	 */
	public static final int GET_AN_OPEN_SALES_ORDER = 402;
	
	/**
	 * SELECT query for getting the charge information like ChargeName and ChargeCategory
	 */
	public static final int GET_CHARGE_INFO_QUERY=403;
	
	/**
	 * PACKAGE call to fetch data for TBL_STG_OPEN_ORDER_LINES from source tables
	 */
	public static final int FETCH_OPEN_ORDERS_QUERY=404;	
	
	public static final int GET_ORDER_NUMBER_FROM_HEADER_ID=405;
	
	public static final int GET_ALL_OPEN_SALES_ORDERS_FOR_SIZE=406;
	
	public static final int IDENTIFY_LEFT_HANDED_FRIDGE_INDICATOR=407;
	
	
	/**
	 * Contains Look up SELECT query for looking up distinct pos store numbers for open sales lines
	 */
	public static final int SELECT_DISTINCT_POS_STORE_QUERY_OSO = 408;
	
	/**
	 * Contains Look up INSERT query for inserting distinct pos store numbers for open sales lines to table TBL_OPEN_LINES_POS_PROVINCE
	 */
	public static final int INSERT_DISTINCT_POS_STORE_QUERY_OSO = 409;
	
	/**
	 * Contains Look up INSERT query for inserting pos PROVINCE for closed sales lines to table TBL_OPEN_LINES_POS_PROVINCE
	 */
	public static final int INSERT_POS_PROVINCE_QUERY_OSO = 410;
	
	/**
	 * Contains Look up SELECT query for looking up pos store numbers and province
	 */
	public static final int GET_POS_STORE_PROVINCE_QUERY_OSO = 420;
	
	/**
	 * Contains Look up for INSERT query for TBL_JMS_QUEUE_STATISTICS
	 */	
	public static final int INSERT_CONVERSION_JMS_STATISTICS_QUERY=48;	

}